package com.kkb.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HosregisterExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public HosregisterExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andHosrIdIsNull() {
            addCriterion("hosR_id is null");
            return (Criteria) this;
        }

        public Criteria andHosrIdIsNotNull() {
            addCriterion("hosR_id is not null");
            return (Criteria) this;
        }

        public Criteria andHosrIdEqualTo(Integer value) {
            addCriterion("hosR_id =", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdNotEqualTo(Integer value) {
            addCriterion("hosR_id <>", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdGreaterThan(Integer value) {
            addCriterion("hosR_id >", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_id >=", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdLessThan(Integer value) {
            addCriterion("hosR_id <", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_id <=", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdIn(List<Integer> values) {
            addCriterion("hosR_id in", values, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdNotIn(List<Integer> values) {
            addCriterion("hosR_id not in", values, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdBetween(Integer value1, Integer value2) {
            addCriterion("hosR_id between", value1, value2, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_id not between", value1, value2, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarIsNull() {
            addCriterion("hosR_idCar is null");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarIsNotNull() {
            addCriterion("hosR_idCar is not null");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarEqualTo(String value) {
            addCriterion("hosR_idCar =", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotEqualTo(String value) {
            addCriterion("hosR_idCar <>", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarGreaterThan(String value) {
            addCriterion("hosR_idCar >", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_idCar >=", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarLessThan(String value) {
            addCriterion("hosR_idCar <", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarLessThanOrEqualTo(String value) {
            addCriterion("hosR_idCar <=", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarLike(String value) {
            addCriterion("hosR_idCar like", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotLike(String value) {
            addCriterion("hosR_idCar not like", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarIn(List<String> values) {
            addCriterion("hosR_idCar in", values, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotIn(List<String> values) {
            addCriterion("hosR_idCar not in", values, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarBetween(String value1, String value2) {
            addCriterion("hosR_idCar between", value1, value2, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotBetween(String value1, String value2) {
            addCriterion("hosR_idCar not between", value1, value2, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalIsNull() {
            addCriterion("hosR_medical is null");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalIsNotNull() {
            addCriterion("hosR_medical is not null");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalEqualTo(String value) {
            addCriterion("hosR_medical =", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotEqualTo(String value) {
            addCriterion("hosR_medical <>", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalGreaterThan(String value) {
            addCriterion("hosR_medical >", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_medical >=", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalLessThan(String value) {
            addCriterion("hosR_medical <", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalLessThanOrEqualTo(String value) {
            addCriterion("hosR_medical <=", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalLike(String value) {
            addCriterion("hosR_medical like", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotLike(String value) {
            addCriterion("hosR_medical not like", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalIn(List<String> values) {
            addCriterion("hosR_medical in", values, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotIn(List<String> values) {
            addCriterion("hosR_medical not in", values, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalBetween(String value1, String value2) {
            addCriterion("hosR_medical between", value1, value2, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotBetween(String value1, String value2) {
            addCriterion("hosR_medical not between", value1, value2, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceIsNull() {
            addCriterion("hosR_regPrice is null");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceIsNotNull() {
            addCriterion("hosR_regPrice is not null");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceEqualTo(Double value) {
            addCriterion("hosR_regPrice =", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceNotEqualTo(Double value) {
            addCriterion("hosR_regPrice <>", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceGreaterThan(Double value) {
            addCriterion("hosR_regPrice >", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("hosR_regPrice >=", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceLessThan(Double value) {
            addCriterion("hosR_regPrice <", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceLessThanOrEqualTo(Double value) {
            addCriterion("hosR_regPrice <=", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceIn(List<Double> values) {
            addCriterion("hosR_regPrice in", values, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceNotIn(List<Double> values) {
            addCriterion("hosR_regPrice not in", values, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceBetween(Double value1, Double value2) {
            addCriterion("hosR_regPrice between", value1, value2, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceNotBetween(Double value1, Double value2) {
            addCriterion("hosR_regPrice not between", value1, value2, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneIsNull() {
            addCriterion("hosR_phone is null");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneIsNotNull() {
            addCriterion("hosR_phone is not null");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneEqualTo(String value) {
            addCriterion("hosR_phone =", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotEqualTo(String value) {
            addCriterion("hosR_phone <>", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneGreaterThan(String value) {
            addCriterion("hosR_phone >", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_phone >=", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneLessThan(String value) {
            addCriterion("hosR_phone <", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneLessThanOrEqualTo(String value) {
            addCriterion("hosR_phone <=", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneLike(String value) {
            addCriterion("hosR_phone like", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotLike(String value) {
            addCriterion("hosR_phone not like", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneIn(List<String> values) {
            addCriterion("hosR_phone in", values, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotIn(List<String> values) {
            addCriterion("hosR_phone not in", values, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneBetween(String value1, String value2) {
            addCriterion("hosR_phone between", value1, value2, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotBetween(String value1, String value2) {
            addCriterion("hosR_phone not between", value1, value2, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceIsNull() {
            addCriterion("hosR_selfPrice is null");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceIsNotNull() {
            addCriterion("hosR_selfPrice is not null");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceEqualTo(Integer value) {
            addCriterion("hosR_selfPrice =", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceNotEqualTo(Integer value) {
            addCriterion("hosR_selfPrice <>", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceGreaterThan(Integer value) {
            addCriterion("hosR_selfPrice >", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_selfPrice >=", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceLessThan(Integer value) {
            addCriterion("hosR_selfPrice <", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_selfPrice <=", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceIn(List<Integer> values) {
            addCriterion("hosR_selfPrice in", values, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceNotIn(List<Integer> values) {
            addCriterion("hosR_selfPrice not in", values, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceBetween(Integer value1, Integer value2) {
            addCriterion("hosR_selfPrice between", value1, value2, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_selfPrice not between", value1, value2, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSexIsNull() {
            addCriterion("hosR_sex is null");
            return (Criteria) this;
        }

        public Criteria andHosrSexIsNotNull() {
            addCriterion("hosR_sex is not null");
            return (Criteria) this;
        }

        public Criteria andHosrSexEqualTo(Integer value) {
            addCriterion("hosR_sex =", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexNotEqualTo(Integer value) {
            addCriterion("hosR_sex <>", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexGreaterThan(Integer value) {
            addCriterion("hosR_sex >", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_sex >=", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexLessThan(Integer value) {
            addCriterion("hosR_sex <", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_sex <=", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexIn(List<Integer> values) {
            addCriterion("hosR_sex in", values, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexNotIn(List<Integer> values) {
            addCriterion("hosR_sex not in", values, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexBetween(Integer value1, Integer value2) {
            addCriterion("hosR_sex between", value1, value2, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_sex not between", value1, value2, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrAgeIsNull() {
            addCriterion("hosR_age is null");
            return (Criteria) this;
        }

        public Criteria andHosrAgeIsNotNull() {
            addCriterion("hosR_age is not null");
            return (Criteria) this;
        }

        public Criteria andHosrAgeEqualTo(Integer value) {
            addCriterion("hosR_age =", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeNotEqualTo(Integer value) {
            addCriterion("hosR_age <>", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeGreaterThan(Integer value) {
            addCriterion("hosR_age >", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_age >=", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeLessThan(Integer value) {
            addCriterion("hosR_age <", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_age <=", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeIn(List<Integer> values) {
            addCriterion("hosR_age in", values, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeNotIn(List<Integer> values) {
            addCriterion("hosR_age not in", values, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeBetween(Integer value1, Integer value2) {
            addCriterion("hosR_age between", value1, value2, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_age not between", value1, value2, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrWorkIsNull() {
            addCriterion("hosR_work is null");
            return (Criteria) this;
        }

        public Criteria andHosrWorkIsNotNull() {
            addCriterion("hosR_work is not null");
            return (Criteria) this;
        }

        public Criteria andHosrWorkEqualTo(String value) {
            addCriterion("hosR_work =", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkNotEqualTo(String value) {
            addCriterion("hosR_work <>", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkGreaterThan(String value) {
            addCriterion("hosR_work >", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_work >=", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkLessThan(String value) {
            addCriterion("hosR_work <", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkLessThanOrEqualTo(String value) {
            addCriterion("hosR_work <=", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkLike(String value) {
            addCriterion("hosR_work like", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkNotLike(String value) {
            addCriterion("hosR_work not like", value, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkIn(List<String> values) {
            addCriterion("hosR_work in", values, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkNotIn(List<String> values) {
            addCriterion("hosR_work not in", values, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkBetween(String value1, String value2) {
            addCriterion("hosR_work between", value1, value2, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrWorkNotBetween(String value1, String value2) {
            addCriterion("hosR_work not between", value1, value2, "hosrWork");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorIsNull() {
            addCriterion("hosR_lookDoctor is null");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorIsNotNull() {
            addCriterion("hosR_lookDoctor is not null");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorEqualTo(Integer value) {
            addCriterion("hosR_lookDoctor =", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotEqualTo(Integer value) {
            addCriterion("hosR_lookDoctor <>", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorGreaterThan(Integer value) {
            addCriterion("hosR_lookDoctor >", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_lookDoctor >=", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorLessThan(Integer value) {
            addCriterion("hosR_lookDoctor <", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_lookDoctor <=", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorIn(List<Integer> values) {
            addCriterion("hosR_lookDoctor in", values, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotIn(List<Integer> values) {
            addCriterion("hosR_lookDoctor not in", values, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorBetween(Integer value1, Integer value2) {
            addCriterion("hosR_lookDoctor between", value1, value2, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_lookDoctor not between", value1, value2, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andDIdIsNull() {
            addCriterion("d_id is null");
            return (Criteria) this;
        }

        public Criteria andDIdIsNotNull() {
            addCriterion("d_id is not null");
            return (Criteria) this;
        }

        public Criteria andDIdEqualTo(Integer value) {
            addCriterion("d_id =", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdNotEqualTo(Integer value) {
            addCriterion("d_id <>", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdGreaterThan(Integer value) {
            addCriterion("d_id >", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("d_id >=", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdLessThan(Integer value) {
            addCriterion("d_id <", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdLessThanOrEqualTo(Integer value) {
            addCriterion("d_id <=", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdIn(List<Integer> values) {
            addCriterion("d_id in", values, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdNotIn(List<Integer> values) {
            addCriterion("d_id not in", values, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdBetween(Integer value1, Integer value2) {
            addCriterion("d_id between", value1, value2, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdNotBetween(Integer value1, Integer value2) {
            addCriterion("d_id not between", value1, value2, "dId");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkIsNull() {
            addCriterion("hosR_remark is null");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkIsNotNull() {
            addCriterion("hosR_remark is not null");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkEqualTo(String value) {
            addCriterion("hosR_remark =", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotEqualTo(String value) {
            addCriterion("hosR_remark <>", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkGreaterThan(String value) {
            addCriterion("hosR_remark >", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_remark >=", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkLessThan(String value) {
            addCriterion("hosR_remark <", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkLessThanOrEqualTo(String value) {
            addCriterion("hosR_remark <=", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkLike(String value) {
            addCriterion("hosR_remark like", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotLike(String value) {
            addCriterion("hosR_remark not like", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkIn(List<String> values) {
            addCriterion("hosR_remark in", values, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotIn(List<String> values) {
            addCriterion("hosR_remark not in", values, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkBetween(String value1, String value2) {
            addCriterion("hosR_remark between", value1, value2, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotBetween(String value1, String value2) {
            addCriterion("hosR_remark not between", value1, value2, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrStateIsNull() {
            addCriterion("hosR_state is null");
            return (Criteria) this;
        }

        public Criteria andHosrStateIsNotNull() {
            addCriterion("hosR_state is not null");
            return (Criteria) this;
        }

        public Criteria andHosrStateEqualTo(Integer value) {
            addCriterion("hosR_state =", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateNotEqualTo(Integer value) {
            addCriterion("hosR_state <>", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateGreaterThan(Integer value) {
            addCriterion("hosR_state >", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_state >=", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateLessThan(Integer value) {
            addCriterion("hosR_state <", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_state <=", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateIn(List<Integer> values) {
            addCriterion("hosR_state in", values, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateNotIn(List<Integer> values) {
            addCriterion("hosR_state not in", values, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateBetween(Integer value1, Integer value2) {
            addCriterion("hosR_state between", value1, value2, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_state not between", value1, value2, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrDateIsNull() {
            addCriterion("hosR_date is null");
            return (Criteria) this;
        }

        public Criteria andHosrDateIsNotNull() {
            addCriterion("hosR_date is not null");
            return (Criteria) this;
        }

        public Criteria andHosrDateEqualTo(Date value) {
            addCriterion("hosR_date =", value, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateNotEqualTo(Date value) {
            addCriterion("hosR_date <>", value, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateGreaterThan(Date value) {
            addCriterion("hosR_date >", value, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateGreaterThanOrEqualTo(Date value) {
            addCriterion("hosR_date >=", value, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateLessThan(Date value) {
            addCriterion("hosR_date <", value, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateLessThanOrEqualTo(Date value) {
            addCriterion("hosR_date <=", value, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateIn(List<Date> values) {
            addCriterion("hosR_date in", values, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateNotIn(List<Date> values) {
            addCriterion("hosR_date not in", values, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateBetween(Date value1, Date value2) {
            addCriterion("hosR_date between", value1, value2, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDateNotBetween(Date value1, Date value2) {
            addCriterion("hosR_date not between", value1, value2, "hosrDate");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidIsNull() {
            addCriterion("hosR_departID is null");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidIsNotNull() {
            addCriterion("hosR_departID is not null");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidEqualTo(Integer value) {
            addCriterion("hosR_departID =", value, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidNotEqualTo(Integer value) {
            addCriterion("hosR_departID <>", value, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidGreaterThan(Integer value) {
            addCriterion("hosR_departID >", value, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_departID >=", value, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidLessThan(Integer value) {
            addCriterion("hosR_departID <", value, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_departID <=", value, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidIn(List<Integer> values) {
            addCriterion("hosR_departID in", values, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidNotIn(List<Integer> values) {
            addCriterion("hosR_departID not in", values, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidBetween(Integer value1, Integer value2) {
            addCriterion("hosR_departID between", value1, value2, "hosrDepartid");
            return (Criteria) this;
        }

        public Criteria andHosrDepartidNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_departID not between", value1, value2, "hosrDepartid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}